Dataset info
| Number of variables | 46 |
|---|---|
| Number of observations | 16947 |
| Missing cells | 11177 (1.4%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 5.9 MiB |
| Average record size in memory | 368.0 B |
Variables types
| Numeric | 8 |
|---|---|
| Categorical | 28 |
| Boolean | 4 |
| Date | 6 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 0 |
| Unsupported | 0 |
Warnings
Account_Name has a high cardinality: 1635 distinct values | Warning |
ASP has 301 (1.8%) zeros | Zeros |
ASP has 3209 (18.9%) missing values | Missing |
ASP_(converted) is highly skewed (γ1 = 80.47407411) | Skewed |
ASP_(converted) has 300 (1.8%) zeros | Zeros |
ASP_(converted) has 3209 (18.9%) missing values | Missing |
Billing_Country has a high cardinality: 80 distinct values | Warning |
Last_Modified_By has a high cardinality: 55 distinct values | Warning |
Month has a high cardinality: 53 distinct values | Warning |
Opportunity_Name has a high cardinality: 9841 distinct values | Warning |
Opportunity_Owner has a high cardinality: 53 distinct values | Warning |
Price has a high cardinality: 53 distinct values | Warning |
Product_Family has a high cardinality: 227 distinct values | Warning |
Product_Name has a high cardinality: 456 distinct values | Warning |
Quote_Expiry_Date has 4625 (27.3%) missing values | Missing |
Sales_Contract_No has a high cardinality: 5267 distinct values | Warning |
Territory has a high cardinality: 76 distinct values | Warning |
Total_Amount is highly skewed (γ1 = 42.00442155) | Skewed |
Total_Taxable_Amount is highly skewed (γ1 = 33.59918963) | Skewed |
Total_Taxable_Amount has 997 (5.9%) zeros | Zeros |
TRF has 11971 (70.6%) zeros | Zeros |
Account_Created_Date
Date
| Distinct count | 809 |
|---|---|
| Unique (%) | 4.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 2013-07-27 00:00:00 |
|---|---|
| Maximum | 2018-12-21 00:00:00 |
Account_Name
Categorical
| Distinct count | 1635 |
|---|---|
| Unique (%) | 9.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Account_Name_1888 | 2124 |
|---|---|
| Account_Name_1836 | 886 |
| Account_Name_25 | 752 |
| Other values (1632) |
| Value | Count | Frequency (%) | |
| Account_Name_1888 | 2124 | 12.5% | |
| Account_Name_1836 | 886 | 5.2% | |
| Account_Name_25 | 752 | 4.4% | |
| Account_Name_1991 | 586 | 3.5% | |
| Account_Name_1642 | 397 | 2.3% | |
| Account_Name_1508 | 355 | 2.1% | |
| Account_Name_1440 | 317 | 1.9% | |
| Account_Name_533 | 283 | 1.7% | |
| Account_Name_263 | 249 | 1.5% | |
| Account_Name_660 | 231 | 1.4% | |
| Other values (1625) | 10767 | 63.5% |
| Max length | 17 |
|---|---|
| Mean length | 16.51560748 |
| Min length | 14 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Account_Owner
Categorical
| Distinct count | 48 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Person_Name_50 | |
|---|---|
| Person_Name_13 | 1328 |
| Person_Name_8 | 1286 |
| Other values (45) |
| Value | Count | Frequency (%) | |
| Person_Name_50 | 3730 | 22.0% | |
| Person_Name_13 | 1328 | 7.8% | |
| Person_Name_8 | 1286 | 7.6% | |
| Person_Name_43 | 1241 | 7.3% | |
| Person_Name_18 | 1093 | 6.4% | |
| Person_Name_3 | 875 | 5.2% | |
| Person_Name_32 | 682 | 4.0% | |
| Person_Name_4 | 664 | 3.9% | |
| Person_Name_65 | 631 | 3.7% | |
| Person_Name_64 | 577 | 3.4% | |
| Other values (38) | 4840 | 28.6% |
| Max length | 14 |
|---|---|
| Mean length | 13.80090872 |
| Min length | 13 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Account_Type
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Account_Type_2 | |
|---|---|
| Account_Type_0 | |
| Account_Type_5 | |
| Other values (4) | 304 |
| Value | Count | Frequency (%) | |
| Account_Type_2 | 8832 | 52.1% | |
| Account_Type_0 | 5868 | 34.6% | |
| Account_Type_5 | 1943 | 11.5% | |
| Account_Type_1 | 165 | 1.0% | |
| None | 112 | 0.7% | |
| Account_Type_6 | 17 | 0.1% | |
| Account_Type_4 | 10 | 0.1% |
| Max length | 14 |
|---|---|
| Mean length | 13.93391161 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
ASP
Numeric
| Distinct count | 302 |
|---|---|
| Unique (%) | 1.8% |
| Missing (%) | 18.9% |
| Missing (n) | 3209 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 7.012128279 |
|---|---|
| Minimum | 0 |
| Maximum | 80 |
| Zeros (%) | 1.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.25 |
| Q1 | 0.36 |
| Median | 0.4 |
| Q3 | 0.505 |
| 95-th percentile | 59 |
| Maximum | 80 |
| Range | 80 |
| Interquartile range | 0.145 |
Descriptive statistics
| Standard deviation | 18.85835901 |
|---|---|
| Coef of variation | 2.689391617 |
| Kurtosis | 5.261237009 |
| Mean | 7.012128279 |
| MAD | 11.7241345 |
| Skewness | 2.623799882 |
| Sum | 96332.6183 |
| Variance | 355.6377046 |
| Memory size | 132.5 KiB |
| Value | Count | Frequency (%) | |
| 0.38 | 801 | 4.7% | |
| 0.4 | 712 | 4.2% | |
| 0.36 | 564 | 3.3% | |
| 0.42 | 510 | 3.0% | |
| 0.39 | 465 | 2.7% | |
| 0.37 | 365 | 2.2% | |
| 0 | 301 | 1.8% | |
| 0.35 | 295 | 1.7% | |
| 0.34 | 270 | 1.6% | |
| 0.365 | 269 | 1.6% | |
| Other values (291) | 9186 | 54.2% | |
| (Missing) | 3209 | 18.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 301 | 1.8% | |
| 1e-05 | 1 | < 0.1% | |
| 0.15 | 53 | 0.3% | |
| 0.16 | 8 | < 0.1% | |
| 0.17 | 114 | 0.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 80 | 14 | 0.1% | |
| 78 | 86 | 0.5% | |
| 77 | 12 | 0.1% | |
| 76 | 6 | < 0.1% | |
| 75 | 99 | 0.6% |
ASP_(converted)
Numeric
| Distinct count | 442 |
|---|---|
| Unique (%) | 2.6% |
| Missing (%) | 18.9% |
| Missing (n) | 3209 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.4325537043 |
|---|---|
| Minimum | 0 |
| Maximum | 67 |
| Zeros (%) | 1.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.27 |
| Q1 | 0.37326 |
| Median | 0.41285 |
| Q3 | 0.47649 |
| 95-th percentile | 0.63 |
| Maximum | 67 |
| Range | 67 |
| Interquartile range | 0.10323 |
Descriptive statistics
| Standard deviation | 0.7586587831 |
|---|---|
| Coef of variation | 1.753906568 |
| Kurtosis | 6675.953735 |
| Mean | 0.4325537043 |
| MAD | 0.09218016785 |
| Skewness | 80.47407411 |
| Sum | 5942.42279 |
| Variance | 0.5755631491 |
| Memory size | 132.5 KiB |
| Value | Count | Frequency (%) | |
| 0.38 | 570 | 3.4% | |
| 0.4 | 497 | 2.9% | |
| 0.36 | 326 | 1.9% | |
| 0.39 | 325 | 1.9% | |
| 0 | 300 | 1.8% | |
| 0.42 | 294 | 1.7% | |
| 0.40719 | 234 | 1.4% | |
| 0.42982 | 230 | 1.4% | |
| 0.47506 | 216 | 1.3% | |
| 0.45244 | 214 | 1.3% | |
| Other values (431) | 10532 | 62.1% | |
| (Missing) | 3209 | 18.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 300 | 1.8% | |
| 1e-05 | 1 | < 0.1% | |
| 0.00378 | 1 | < 0.1% | |
| 0.15 | 53 | 0.3% | |
| 0.16 | 8 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 67 | 1 | < 0.1% | |
| 57.68578 | 1 | < 0.1% | |
| 1.7 | 1 | < 0.1% | |
| 1.6 | 6 | < 0.1% | |
| 1 | 2 | < 0.1% |
ASP_Currency
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| USD | |
|---|---|
| JPY | |
| EUR | |
| Other values (2) | 561 |
| Value | Count | Frequency (%) | |
| USD | 7361 | 43.4% | |
| JPY | 4522 | 26.7% | |
| EUR | 4503 | 26.6% | |
| AUD | 556 | 3.3% | |
| GBP | 5 | < 0.1% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
Billing_Country
Categorical
| Distinct count | 80 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Japan | |
|---|---|
| United States | |
| Germany | |
| Other values (77) |
| Value | Count | Frequency (%) | |
| Japan | 4879 | 28.8% | |
| United States | 3802 | 22.4% | |
| Germany | 1979 | 11.7% | |
| Australia | 1169 | 6.9% | |
| India | 672 | 4.0% | |
| Netherlands | 563 | 3.3% | |
| Singapore | 432 | 2.5% | |
| France | 396 | 2.3% | |
| Spain | 317 | 1.9% | |
| Italy | 295 | 1.7% | |
| Other values (70) | 2443 | 14.4% |
| Max length | 42 |
|---|---|
| Mean length | 8.187289786 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Brand
Categorical
| Distinct count | 26 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| Other | 607 |
| Brand_9 | 140 |
| Other values (23) | 289 |
| Value | Count | Frequency (%) | |
| None | 15911 | 93.9% | |
| Other | 607 | 3.6% | |
| Brand_9 | 140 | 0.8% | |
| Brand_5 | 48 | 0.3% | |
| Brand_24 | 38 | 0.2% | |
| Brand_11 | 34 | 0.2% | |
| Brand_25 | 24 | 0.1% | |
| Brand_10 | 22 | 0.1% | |
| Brand_22 | 20 | 0.1% | |
| Brand_21 | 17 | 0.1% | |
| Other values (16) | 86 | 0.5% |
| Max length | 8 |
|---|---|
| Mean length | 4.12409276 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Bureaucratic_Code
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Bureaucratic_Code_4 | |
|---|---|
| Bureaucratic_Code_5 | |
| Bureaucratic_Code_1 | 261 |
| Other values (4) | 296 |
| Value | Count | Frequency (%) | |
| Bureaucratic_Code_4 | 12587 | 74.3% | |
| Bureaucratic_Code_5 | 3803 | 22.4% | |
| Bureaucratic_Code_1 | 261 | 1.5% | |
| Bureaucratic_Code_2 | 242 | 1.4% | |
| Bureaucratic_Code_0 | 51 | 0.3% | |
| Bureaucratic_Code_3 | 2 | < 0.1% | |
| Bureaucratic_Code_6 | 1 | < 0.1% |
| Max length | 19 |
|---|---|
| Mean length | 19 |
| Min length | 19 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Bureaucratic_Code_0_Approval
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 8889 | 52.5% | |
| 1 | 8058 | 47.5% |
Bureaucratic_Code_0_Approved
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 11543 | 68.1% | |
| 1 | 5404 | 31.9% |
Currency
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| EUR | 475 |
| USD | 420 |
| Value | Count | Frequency (%) | |
| None | 16052 | 94.7% | |
| EUR | 475 | 2.8% | |
| USD | 420 | 2.5% |
| Max length | 4 |
|---|---|
| Mean length | 3.947188293 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
Delivery_Quarter
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Q2 | |
|---|---|
| Q1 | |
| Q4 |
| Value | Count | Frequency (%) | |
| Q2 | 4443 | 26.2% | |
| Q1 | 4317 | 25.5% | |
| Q4 | 4144 | 24.5% | |
| Q3 | 4043 | 23.9% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Delivery_Terms
Categorical
| Distinct count | 9 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Delivery_Terms_4 | |
|---|---|
| Delivery_Terms_2 | |
| Delivery_Terms_1 | |
| Other values (6) |
| Value | Count | Frequency (%) | |
| Delivery_Terms_4 | 7712 | 45.5% | |
| Delivery_Terms_2 | 4633 | 27.3% | |
| Delivery_Terms_1 | 2936 | 17.3% | |
| Delivery_Terms_6 | 781 | 4.6% | |
| Delivery_Terms_5 | 636 | 3.8% | |
| Delivery_Terms_8 | 164 | 1.0% | |
| Delivery_Terms_3 | 41 | 0.2% | |
| Delivery_Terms_7 | 38 | 0.2% | |
| Delivery_Terms_0 | 6 | < 0.1% |
| Max length | 16 |
|---|---|
| Mean length | 16 |
| Min length | 16 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Delivery_Year
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2017.137428 |
|---|---|
| Minimum | 2016 |
| Maximum | 2020 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2016 |
|---|---|
| 5-th percentile | 2016 |
| Q1 | 2016 |
| Median | 2017 |
| Q3 | 2018 |
| 95-th percentile | 2018 |
| Maximum | 2020 |
| Range | 4 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 0.8296028156 |
|---|---|
| Coef of variation | 0.0004112772902 |
| Kurtosis | -0.9481673267 |
| Mean | 2017.137428 |
| MAD | 0.6892043121 |
| Skewness | 0.03065373257 |
| Sum | 34184428 |
| Variance | 0.6882408316 |
| Memory size | 132.5 KiB |
| Value | Count | Frequency (%) | |
| 2017 | 6318 | 37.3% | |
| 2018 | 5830 | 34.4% | |
| 2016 | 4371 | 25.8% | |
| 2019 | 414 | 2.4% | |
| 2020 | 14 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2016 | 4371 | 25.8% | |
| 2017 | 6318 | 37.3% | |
| 2018 | 5830 | 34.4% | |
| 2019 | 414 | 2.4% | |
| 2020 | 14 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2020 | 14 | 0.1% | |
| 2019 | 414 | 2.4% | |
| 2018 | 5830 | 34.4% | |
| 2017 | 6318 | 37.3% | |
| 2016 | 4371 | 25.8% |
ID
Numeric
| Distinct count | 16947 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 17666.65044 |
|---|---|
| Minimum | 4854 |
| Maximum | 28773 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 4854 |
|---|---|
| 5-th percentile | 6095.3 |
| Q1 | 11953 |
| Median | 18114 |
| Q3 | 23845.5 |
| 95-th percentile | 27687.4 |
| Maximum | 28773 |
| Range | 23919 |
| Interquartile range | 11892.5 |
Descriptive statistics
| Standard deviation | 6940.859372 |
|---|---|
| Coef of variation | 0.3928791933 |
| Kurtosis | -1.172033787 |
| Mean | 17666.65044 |
| MAD | 5997.31525 |
| Skewness | -0.1785736993 |
| Sum | 299396725 |
| Variance | 48175528.83 |
| Memory size | 132.5 KiB |
| Value | Count | Frequency (%) | |
| 6141 | 1 | < 0.1% | |
| 27384 | 1 | < 0.1% | |
| 21263 | 1 | < 0.1% | |
| 19212 | 1 | < 0.1% | |
| 25353 | 1 | < 0.1% | |
| 27400 | 1 | < 0.1% | |
| 4871 | 1 | < 0.1% | |
| 13059 | 1 | < 0.1% | |
| 15106 | 1 | < 0.1% | |
| 8961 | 1 | < 0.1% | |
| Other values (16937) | 16937 | 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 4854 | 1 | < 0.1% | |
| 4856 | 1 | < 0.1% | |
| 4858 | 1 | < 0.1% | |
| 4859 | 1 | < 0.1% | |
| 4860 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 28773 | 1 | < 0.1% | |
| 28772 | 1 | < 0.1% | |
| 28771 | 1 | < 0.1% | |
| 28770 | 1 | < 0.1% | |
| 28769 | 1 | < 0.1% |
Last_Modified_By
Categorical
| Distinct count | 55 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Person_Name_47 | |
|---|---|
| Person_Name_50 | 1210 |
| Person_Name_43 | 587 |
| Other values (52) |
| Value | Count | Frequency (%) | |
| Person_Name_47 | 8515 | 50.2% | |
| Person_Name_50 | 1210 | 7.1% | |
| Person_Name_43 | 587 | 3.5% | |
| Person_Name_13 | 578 | 3.4% | |
| Person_Name_8 | 511 | 3.0% | |
| Person_Name_18 | 438 | 2.6% | |
| Person_Name_33 | 429 | 2.5% | |
| Person_Name_19 | 395 | 2.3% | |
| Person_Name_3 | 395 | 2.3% | |
| Person_Name_4 | 315 | 1.9% | |
| Other values (45) | 3574 | 21.1% |
| Max length | 14 |
|---|---|
| Mean length | 13.89809406 |
| Min length | 13 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Last_Modified_Date
Date
| Distinct count | 650 |
|---|---|
| Unique (%) | 3.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 2015-03-12 00:00:00 |
|---|---|
| Maximum | 2018-12-29 00:00:00 |
Month
Categorical
| Distinct count | 53 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2018 - 10 | 666 |
|---|---|
| 2017 - 6 | 643 |
| 2017 - 10 | 638 |
| Other values (50) |
| Value | Count | Frequency (%) | |
| 2018 - 10 | 666 | 3.9% | |
| 2017 - 6 | 643 | 3.8% | |
| 2017 - 10 | 638 | 3.8% | |
| 2016 - 3 | 628 | 3.7% | |
| 2017 - 7 | 625 | 3.7% | |
| 2017 - 5 | 586 | 3.5% | |
| 2018 - 4 | 579 | 3.4% | |
| 2017 - 12 | 574 | 3.4% | |
| 2018 - 6 | 542 | 3.2% | |
| 2018 - 7 | 536 | 3.2% | |
| Other values (43) | 10930 | 64.5% |
| Max length | 9 |
|---|---|
| Mean length | 8.244527055 |
| Min length | 8 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Opportunity_Created_Date
Date
| Distinct count | 1096 |
|---|---|
| Unique (%) | 6.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 2013-11-05 00:00:00 |
|---|---|
| Maximum | 2018-12-29 00:00:00 |
Opportunity_ID
Numeric
| Distinct count | 9841 |
|---|---|
| Unique (%) | 58.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5335.940225 |
|---|---|
| Minimum | 0 |
| Maximum | 12803 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 435.3 |
| Q1 | 2448.5 |
| Median | 5306 |
| Q3 | 7698 |
| 95-th percentile | 11203.5 |
| Maximum | 12803 |
| Range | 12803 |
| Interquartile range | 5249.5 |
Descriptive statistics
| Standard deviation | 3324.723809 |
|---|---|
| Coef of variation | 0.623081157 |
| Kurtosis | -0.7150386945 |
| Mean | 5335.940225 |
| MAD | 2797.70729 |
| Skewness | 0.2852975553 |
| Sum | 90428179 |
| Variance | 11053788.41 |
| Memory size | 132.5 KiB |
| Value | Count | Frequency (%) | |
| 12460 | 36 | 0.2% | |
| 2008 | 36 | 0.2% | |
| 5123 | 26 | 0.2% | |
| 6606 | 26 | 0.2% | |
| 2911 | 24 | 0.1% | |
| 767 | 18 | 0.1% | |
| 6654 | 16 | 0.1% | |
| 8698 | 16 | 0.1% | |
| 6653 | 16 | 0.1% | |
| 7568 | 16 | 0.1% | |
| Other values (9831) | 16717 | 98.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 12803 | 1 | < 0.1% | |
| 12802 | 1 | < 0.1% | |
| 12801 | 3 | < 0.1% | |
| 12800 | 2 | < 0.1% | |
| 12799 | 1 | < 0.1% |
Opportunity_Name
Categorical
| Distinct count | 9841 |
|---|---|
| Unique (%) | 58.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Opportunity_Name_5036 | 36 |
|---|---|
| Opportunity_Name_9795 | 36 |
| Opportunity_Name_12179 | 26 |
| Other values (9838) |
| Value | Count | Frequency (%) | |
| Opportunity_Name_5036 | 36 | 0.2% | |
| Opportunity_Name_9795 | 36 | 0.2% | |
| Opportunity_Name_12179 | 26 | 0.2% | |
| Opportunity_Name_11461 | 26 | 0.2% | |
| Opportunity_Name_6835 | 24 | 0.1% | |
| Opportunity_Name_1661 | 18 | 0.1% | |
| Opportunity_Name_9628 | 16 | 0.1% | |
| Opportunity_Name_10131 | 16 | 0.1% | |
| Opportunity_Name_10944 | 16 | 0.1% | |
| Opportunity_Name_10945 | 16 | 0.1% | |
| Other values (9831) | 16717 | 98.6% |
| Max length | 22 |
|---|---|
| Mean length | 21.15271139 |
| Min length | 18 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Opportunity_Owner
Categorical
| Distinct count | 53 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Person_Name_50 | |
|---|---|
| Person_Name_8 | 1422 |
| Person_Name_13 | 1254 |
| Other values (50) |
| Value | Count | Frequency (%) | |
| Person_Name_50 | 3781 | 22.3% | |
| Person_Name_8 | 1422 | 8.4% | |
| Person_Name_13 | 1254 | 7.4% | |
| Person_Name_18 | 982 | 5.8% | |
| Person_Name_43 | 838 | 4.9% | |
| Person_Name_3 | 832 | 4.9% | |
| Person_Name_4 | 687 | 4.1% | |
| Person_Name_32 | 686 | 4.0% | |
| Person_Name_19 | 615 | 3.6% | |
| Person_Name_64 | 516 | 3.0% | |
| Other values (43) | 5334 | 31.5% |
| Max length | 14 |
|---|---|
| Mean length | 13.8094648 |
| Min length | 13 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Opportunity_Type
Categorical
| Distinct count | 25 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Opportunity_Type_1 | |
|---|---|
| Opportunity_Type_7 | |
| Opportunity_Type_19 | |
| Other values (22) |
| Value | Count | Frequency (%) | |
| Opportunity_Type_1 | 6819 | 40.2% | |
| Opportunity_Type_7 | 5763 | 34.0% | |
| Opportunity_Type_19 | 1900 | 11.2% | |
| Opportunity_Type_8 | 1458 | 8.6% | |
| Opportunity_Type_12 | 279 | 1.6% | |
| Opportunity_Type_3 | 275 | 1.6% | |
| Opportunity_Type_20 | 175 | 1.0% | |
| Opportunity_Type_2 | 70 | 0.4% | |
| Opportunity_Type_4 | 51 | 0.3% | |
| Opportunity_Type_10 | 34 | 0.2% | |
| Other values (15) | 123 | 0.7% |
| Max length | 19 |
|---|---|
| Mean length | 18.14539447 |
| Min length | 18 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Planned_Delivery_End_Date
Date
| Distinct count | 1017 |
|---|---|
| Unique (%) | 6.0% |
| Missing (%) | 0.4% |
| Missing (n) | 75 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 2016-01-05 00:00:00 |
|---|---|
| Maximum | 2208-12-31 00:00:00 |
Planned_Delivery_Start_Date
Date
| Distinct count | 986 |
|---|---|
| Unique (%) | 5.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 2016-01-01 00:00:00 |
|---|---|
| Maximum | 2020-09-17 00:00:00 |
Price
Categorical
| Distinct count | 53 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| Other | 609 |
| 0.24 | 27 |
| Other values (50) | 329 |
| Value | Count | Frequency (%) | |
| None | 15982 | 94.3% | |
| Other | 609 | 3.6% | |
| 0.24 | 27 | 0.2% | |
| 0.41 | 22 | 0.1% | |
| 0.28 | 20 | 0.1% | |
| 0.27 | 18 | 0.1% | |
| 0.29 | 17 | 0.1% | |
| 0.32 | 15 | 0.1% | |
| 0.38 | 14 | 0.1% | |
| 0.35 | 14 | 0.1% | |
| Other values (43) | 209 | 1.2% |
| Max length | 5 |
|---|---|
| Mean length | 4.039062961 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Pricing,_Delivery_Terms_Approved
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 9890 | 58.4% | |
| 0 | 7057 | 41.6% |
Pricing,_Delivery_Terms_Quote_Appr
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 13693 | 80.8% | |
| 0 | 3254 | 19.2% |
Product_Category_B
Categorical
| Distinct count | 28 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| Other | 523 |
| Product_Category_B_2 | 59 |
| Other values (25) | 437 |
| Value | Count | Frequency (%) | |
| None | 15928 | 94.0% | |
| Other | 523 | 3.1% | |
| Product_Category_B_2 | 59 | 0.3% | |
| Product_Category_B_12 | 51 | 0.3% | |
| Product_Category_B_7 | 47 | 0.3% | |
| Product_Category_B_4 | 37 | 0.2% | |
| Product_Category_B_5 | 36 | 0.2% | |
| Product_Category_B_17 | 27 | 0.2% | |
| Product_Category_B_1 | 24 | 0.1% | |
| Product_Category_B_8 | 23 | 0.1% | |
| Other values (18) | 192 | 1.1% |
| Max length | 21 |
|---|---|
| Mean length | 4.512008025 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Product_Family
Categorical
| Distinct count | 227 |
|---|---|
| Unique (%) | 1.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Product_Family_77 | 1345 |
|---|---|
| Product_Family_133 | 1249 |
| Product_Family_132 | 763 |
| Other values (224) |
| Value | Count | Frequency (%) | |
| Product_Family_77 | 1345 | 7.9% | |
| Product_Family_133 | 1249 | 7.4% | |
| Product_Family_132 | 763 | 4.5% | |
| Product_Family_212 | 636 | 3.8% | |
| Product_Family_100 | 619 | 3.7% | |
| Product_Family_85 | 596 | 3.5% | |
| Product_Family_115 | 540 | 3.2% | |
| Product_Family_226 | 524 | 3.1% | |
| Product_Family_109 | 499 | 2.9% | |
| Product_Family_208 | 478 | 2.8% | |
| Other values (217) | 9698 | 57.2% |
| Max length | 18 |
|---|---|
| Mean length | 17.6441258 |
| Min length | 16 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Product_Name
Categorical
| Distinct count | 456 |
|---|---|
| Unique (%) | 2.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Product_Name_100 | 976 |
|---|---|
| Product_Name_226 | 836 |
| Product_Name_231 | 579 |
| Other values (453) |
| Value | Count | Frequency (%) | |
| Product_Name_100 | 976 | 5.8% | |
| Product_Name_226 | 836 | 4.9% | |
| Product_Name_231 | 579 | 3.4% | |
| Product_Name_491 | 524 | 3.1% | |
| Product_Name_4 | 474 | 2.8% | |
| Product_Name_192 | 442 | 2.6% | |
| Product_Name_111 | 388 | 2.3% | |
| Product_Name_132 | 383 | 2.3% | |
| Product_Name_495 | 350 | 2.1% | |
| Product_Name_29 | 345 | 2.0% | |
| Other values (446) | 11650 | 68.7% |
| Max length | 16 |
|---|---|
| Mean length | 15.74609075 |
| Min length | 14 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Product_Type
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| Other | 515 |
| Product_Type_3 | 179 |
| Other values (4) | 318 |
| Value | Count | Frequency (%) | |
| None | 15935 | 94.0% | |
| Other | 515 | 3.0% | |
| Product_Type_3 | 179 | 1.1% | |
| Product_Type_1 | 142 | 0.8% | |
| Product_Type_0 | 94 | 0.6% | |
| Product_Type_4 | 73 | 0.4% | |
| Product_Type_2 | 9 | 0.1% |
| Max length | 14 |
|---|---|
| Mean length | 4.323656104 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Quote_Expiry_Date
Date
| Distinct count | 1003 |
|---|---|
| Unique (%) | 5.9% |
| Missing (%) | 27.3% |
| Missing (n) | 4625 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Minimum | 2014-09-30 00:00:00 |
|---|---|
| Maximum | 2019-06-30 00:00:00 |
Quote_Type
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Non Binding | |
|---|---|
| Binding | 170 |
| Value | Count | Frequency (%) | |
| Non Binding | 16777 | 99.0% | |
| Binding | 170 | 1.0% |
| Max length | 11 |
|---|---|
| Mean length | 10.9598749 |
| Min length | 7 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Region
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Japan | |
|---|---|
| EMEA | |
| Americas | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| Japan | 4892 | 28.9% | |
| EMEA | 4664 | 27.5% | |
| Americas | 3945 | 23.3% | |
| APAC | 3262 | 19.2% | |
| Middle East | 184 | 1.1% |
| Max length | 11 |
|---|---|
| Mean length | 5.295804567 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Sales_Contract_No
Categorical
| Distinct count | 5267 |
|---|---|
| Unique (%) | 31.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| 479 | 36 |
| 108 | 36 |
| Other values (5264) |
| Value | Count | Frequency (%) | |
| None | 6973 | 41.1% | |
| 479 | 36 | 0.2% | |
| 108 | 36 | 0.2% | |
| 2575 | 18 | 0.1% | |
| 3878 | 16 | 0.1% | |
| 3877 | 16 | 0.1% | |
| 3980 | 16 | 0.1% | |
| 5583 | 16 | 0.1% | |
| 3876 | 16 | 0.1% | |
| 3123 | 16 | 0.1% | |
| Other values (5257) | 9788 | 57.8% |
| Max length | 4 |
|---|---|
| Mean length | 3.875376173 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Size
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| Other | 394 |
| Size_3 | 356 |
| Other values (4) | 230 |
| Value | Count | Frequency (%) | |
| None | 15967 | 94.2% | |
| Other | 394 | 2.3% | |
| Size_3 | 356 | 2.1% | |
| Size_4 | 196 | 1.2% | |
| Size_1 | 25 | 0.1% | |
| Size_0 | 7 | < 0.1% | |
| Size_2 | 2 | < 0.1% |
| Max length | 6 |
|---|---|
| Mean length | 4.092405736 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Source_
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| Source_7 | |
| Source_9 | 1459 |
| Other values (11) |
| Value | Count | Frequency (%) | |
| None | 9497 | 56.0% | |
| Source_7 | 2965 | 17.5% | |
| Source_9 | 1459 | 8.6% | |
| Source_11 | 1421 | 8.4% | |
| Source_13 | 786 | 4.6% | |
| Source_3 | 418 | 2.5% | |
| Source_1 | 137 | 0.8% | |
| Source_10 | 106 | 0.6% | |
| Source_2 | 86 | 0.5% | |
| Source_4 | 43 | 0.3% | |
| Other values (4) | 29 | 0.2% |
| Max length | 9 |
|---|---|
| Mean length | 5.895025668 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Stage
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Closed Won | |
|---|---|
| Closed Lost | |
| Proposal | 35 |
| Other values (2) | 29 |
| Value | Count | Frequency (%) | |
| Closed Won | 9533 | 56.3% | |
| Closed Lost | 7350 | 43.4% | |
| Proposal | 35 | 0.2% | |
| Negotiation | 18 | 0.1% | |
| Qualification | 11 | 0.1% |
| Max length | 13 |
|---|---|
| Mean length | 10.43258394 |
| Min length | 8 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Territory
Categorical
| Distinct count | 76 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| Germany | 1682 |
| NW America | 1568 |
| Other values (73) |
| Value | Count | Frequency (%) | |
| None | 4999 | 29.5% | |
| Germany | 1682 | 9.9% | |
| NW America | 1568 | 9.3% | |
| Australia | 1208 | 7.1% | |
| India | 809 | 4.8% | |
| NE America | 760 | 4.5% | |
| Japan | 681 | 4.0% | |
| Netherlands | 533 | 3.1% | |
| SE America | 493 | 2.9% | |
| France | 449 | 2.6% | |
| Other values (66) | 3765 | 22.2% |
| Max length | 20 |
|---|---|
| Mean length | 7.018646368 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Total_Amount
Numeric
| Distinct count | 8873 |
|---|---|
| Unique (%) | 52.4% |
| Missing (%) | 0.3% |
| Missing (n) | 59 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1993659.215 |
|---|---|
| Minimum | 0 |
| Maximum | 1320000000 |
| Zeros (%) | 0.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2900 |
| Q1 | 26775 |
| Median | 107250 |
| Q3 | 460389.825 |
| 95-th percentile | 7010372.365 |
| Maximum | 1320000000 |
| Range | 1320000000 |
| Interquartile range | 433614.825 |
Descriptive statistics
| Standard deviation | 18484259.88 |
|---|---|
| Coef of variation | 9.271524312 |
| Kurtosis | 2322.422807 |
| Mean | 1993659.215 |
| MAD | 3088832.222 |
| Skewness | 42.00442155 |
| Sum | 3.366891683e+10 |
| Variance | 3.416678634e+14 |
| Memory size | 132.5 KiB |
| Value | Count | Frequency (%) | |
| 6200 | 513 | 3.0% | |
| 4400 | 461 | 2.7% | |
| 18000 | 353 | 2.1% | |
| 140000 | 272 | 1.6% | |
| 1600 | 204 | 1.2% | |
| 160000 | 132 | 0.8% | |
| 109620 | 100 | 0.6% | |
| 23400 | 80 | 0.5% | |
| 85260 | 75 | 0.4% | |
| 81200 | 75 | 0.4% | |
| Other values (8862) | 14623 | 86.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 52 | 0.3% | |
| 0.01 | 7 | < 0.1% | |
| 0.02 | 3 | < 0.1% | |
| 0.04 | 1 | < 0.1% | |
| 0.1 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1320000000 | 1 | < 0.1% | |
| 919992410 | 1 | < 0.1% | |
| 760000000 | 1 | < 0.1% | |
| 660005280 | 1 | < 0.1% | |
| 660004620 | 1 | < 0.1% |
Total_Taxable_Amount
Numeric
| Distinct count | 7096 |
|---|---|
| Unique (%) | 41.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3224116.789 |
|---|---|
| Minimum | 0 |
| Maximum | 1356338620 |
| Zeros (%) | 5.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 85465.8 |
| Median | 376067.25 |
| Q3 | 1037450 |
| 95-th percentile | 12770625 |
| Maximum | 1356338620 |
| Range | 1356338620 |
| Interquartile range | 951984.2 |
Descriptive statistics
| Standard deviation | 20303604.73 |
|---|---|
| Coef of variation | 6.297416022 |
| Kurtosis | 1706.197108 |
| Mean | 3224116.789 |
| MAD | 4753252.673 |
| Skewness | 33.59918963 |
| Sum | 5.463910723e+10 |
| Variance | 4.122363649e+14 |
| Memory size | 132.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 997 | 5.9% | |
| 588325 | 72 | 0.4% | |
| 109620 | 68 | 0.4% | |
| 488700 | 66 | 0.4% | |
| 413700 | 60 | 0.4% | |
| 552400 | 60 | 0.4% | |
| 1767640 | 48 | 0.3% | |
| 523100 | 40 | 0.2% | |
| 105840 | 37 | 0.2% | |
| 31053609.6 | 36 | 0.2% | |
| Other values (7086) | 15463 | 91.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 997 | 5.9% | |
| 0.15 | 1 | < 0.1% | |
| 45 | 1 | < 0.1% | |
| 100.1 | 1 | < 0.1% | |
| 101.4 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1356338620 | 1 | < 0.1% | |
| 919992410 | 1 | < 0.1% | |
| 760000000 | 1 | < 0.1% | |
| 660005280 | 1 | < 0.1% | |
| 660004620 | 1 | < 0.1% |
Total_Taxable_Amount_Currency
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| USD | |
|---|---|
| JPY | |
| EUR | |
| Other values (2) | 557 |
| Value | Count | Frequency (%) | |
| USD | 7347 | 43.4% | |
| JPY | 4525 | 26.7% | |
| EUR | 4518 | 26.7% | |
| AUD | 553 | 3.3% | |
| GBP | 4 | < 0.1% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
TRF
Numeric
| Distinct count | 101 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.338171948 |
|---|---|
| Minimum | 0 |
| Maximum | 500 |
| Zeros (%) | 70.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 10 |
| Maximum | 500 |
| Range | 500 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 12.16933936 |
|---|---|
| Coef of variation | 5.204638339 |
| Kurtosis | 468.696877 |
| Mean | 2.338171948 |
| MAD | 3.674463104 |
| Skewness | 17.060823 |
| Sum | 39625 |
| Variance | 148.0928205 |
| Memory size | 132.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 11971 | 70.6% | |
| 1 | 2192 | 12.9% | |
| 2 | 627 | 3.7% | |
| 3 | 354 | 2.1% | |
| 5 | 297 | 1.8% | |
| 4 | 208 | 1.2% | |
| 10 | 190 | 1.1% | |
| 6 | 131 | 0.8% | |
| 7 | 111 | 0.7% | |
| 20 | 83 | 0.5% | |
| Other values (91) | 783 | 4.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 11971 | 70.6% | |
| 1 | 2192 | 12.9% | |
| 2 | 627 | 3.7% | |
| 3 | 354 | 2.1% | |
| 4 | 208 | 1.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 500 | 1 | < 0.1% | |
| 429 | 1 | < 0.1% | |
| 400 | 2 | < 0.1% | |
| 270 | 1 | < 0.1% | |
| 250 | 1 | < 0.1% |
First rows
| Account_Created_Date | Account_Name | Account_Owner | Account_Type | ASP | ASP_(converted) | ASP_Currency | Billing_Country | Brand | Bureaucratic_Code | Bureaucratic_Code_0_Approval | Bureaucratic_Code_0_Approved | Currency | Delivery_Quarter | Delivery_Terms | Delivery_Year | ID | Last_Modified_By | Last_Modified_Date | Month | Opportunity_Created_Date | Opportunity_ID | Opportunity_Name | Opportunity_Owner | Opportunity_Type | Planned_Delivery_End_Date | Planned_Delivery_Start_Date | Price | Pricing,_Delivery_Terms_Approved | Pricing,_Delivery_Terms_Quote_Appr | Product_Category_B | Product_Family | Product_Name | Product_Type | Quote_Expiry_Date | Quote_Type | Region | Sales_Contract_No | Size | Source_ | Stage | Territory | Total_Amount | Total_Taxable_Amount | Total_Taxable_Amount_Currency | TRF | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2015-06-16 | Account_Name_619 | Person_Name_51 | Account_Type_2 | 0.52 | 0.58817 | EUR | Netherlands | None | Bureaucratic_Code_4 | 1 | 1 | None | Q2 | Delivery_Terms_2 | 2016 | 27761 | Person_Name_18 | 2016-06-13 | 2016 - 5 | 2015-12-07 | 0 | Opportunity_Name_12598 | Person_Name_18 | Opportunity_Type_1 | 2016-06-30 | 2016-05-01 | None | 1 | 1 | None | Product_Family_77 | Product_Name_99 | None | 2016-01-30 | Non Binding | EMEA | None | None | None | Closed Lost | None | 5272800.0 | 5272800.0 | EUR | 10 |
| 1 | 2015-06-16 | Account_Name_619 | Person_Name_51 | Account_Type_2 | 0.53 | 0.59948 | EUR | Netherlands | None | Bureaucratic_Code_4 | 0 | 0 | None | Q1 | Delivery_Terms_2 | 2016 | 27760 | Person_Name_20 | 2016-01-15 | 2016 - 1 | 2015-12-07 | 1 | Opportunity_Name_12600 | Person_Name_20 | Opportunity_Type_1 | 2016-01-20 | 2016-01-18 | None | 0 | 0 | None | Product_Family_77 | Product_Name_100 | None | 2016-01-20 | Non Binding | EMEA | 39 | None | None | Closed Won | None | 48230.0 | 48230.0 | EUR | 0 |
| 2 | 2015-04-21 | Account_Name_1794 | Person_Name_64 | Account_Type_5 | 0.48 | 0.48000 | USD | United States | None | Bureaucratic_Code_4 | 0 | 0 | None | Q1 | Delivery_Terms_4 | 2016 | 27446 | Person_Name_8 | 2016-09-29 | 2016 - 1 | 2015-12-08 | 2 | Opportunity_Name_469 | Person_Name_8 | Opportunity_Type_1 | 2016-01-25 | 2016-01-25 | None | 0 | 0 | None | Product_Family_81 | Product_Name_91 | None | 2016-09-30 | Non Binding | Americas | 760 | None | Source_7 | Closed Won | NW America | 83865.6 | 83865.6 | USD | 0 |
| 3 | 2013-07-27 | Account_Name_1201 | Person_Name_8 | Account_Type_5 | 0.53 | 0.53000 | USD | United States | Other | Bureaucratic_Code_5 | 1 | 0 | USD | Q1 | Delivery_Terms_1 | 2018 | 16808 | Person_Name_8 | 2018-03-27 | 2018 - 2 | 2015-12-08 | 3 | Opportunity_Name_415 | Person_Name_8 | Opportunity_Type_19 | 2018-03-31 | 2018-02-01 | 0.42 | 0 | 1 | Product_Category_B_16 | Product_Family_209 | Product_Name_432 | Product_Type_0 | NaT | Non Binding | Americas | None | Size_4 | Source_11 | Closed Lost | NW America | 7421881.5 | 7421881.5 | USD | 14 |
| 4 | 2013-07-27 | Account_Name_1201 | Person_Name_8 | Account_Type_5 | 0.53 | 0.53000 | USD | United States | Other | Bureaucratic_Code_5 | 1 | 0 | USD | Q1 | Delivery_Terms_1 | 2018 | 16805 | Person_Name_8 | 2018-03-27 | 2018 - 2 | 2015-12-08 | 4 | Opportunity_Name_851 | Person_Name_8 | Opportunity_Type_19 | 2018-02-28 | 2018-02-01 | 0.42 | 0 | 1 | Product_Category_B_16 | Product_Family_209 | Product_Name_432 | Product_Type_0 | 2017-06-02 | Non Binding | Americas | None | Size_4 | Source_11 | Closed Lost | NW America | 13357192.5 | 13357192.5 | USD | 25 |
| 5 | 2013-07-27 | Account_Name_1201 | Person_Name_8 | Account_Type_5 | 0.53 | 0.53000 | USD | United States | Other | Bureaucratic_Code_5 | 1 | 0 | USD | Q1 | Delivery_Terms_1 | 2018 | 16802 | Person_Name_8 | 2018-03-27 | 2018 - 2 | 2015-12-08 | 5 | Opportunity_Name_939 | Person_Name_8 | Opportunity_Type_19 | 2018-03-31 | 2018-02-01 | 0.42 | 0 | 1 | Product_Category_B_16 | Product_Family_209 | Product_Name_432 | Product_Type_0 | 2017-06-02 | Non Binding | Americas | None | Size_4 | Source_11 | Closed Lost | NW America | 14838277.5 | 14838277.5 | USD | 28 |
| 6 | 2013-07-27 | Account_Name_1201 | Person_Name_8 | Account_Type_5 | 0.38 | 0.38000 | USD | United States | None | Bureaucratic_Code_5 | 1 | 0 | None | Q1 | Delivery_Terms_4 | 2017 | 16799 | Person_Name_8 | 2016-10-07 | 2017 - 2 | 2015-12-08 | 6 | Opportunity_Name_1618 | Person_Name_8 | Opportunity_Type_19 | 2017-05-01 | 2017-02-01 | None | 0 | 1 | None | Product_Family_164 | Product_Name_308 | None | NaT | Non Binding | Americas | None | None | Source_11 | Closed Lost | NW America | 2659494.6 | 2659494.6 | USD | 7 |
| 7 | 2015-04-21 | Account_Name_1794 | Person_Name_64 | Account_Type_5 | 0.48 | 0.48000 | USD | United States | None | Bureaucratic_Code_4 | 1 | 1 | None | Q1 | Delivery_Terms_4 | 2016 | 27455 | Person_Name_8 | 2015-12-09 | 2016 - 1 | 2015-12-09 | 7 | Opportunity_Name_8227 | Person_Name_8 | Opportunity_Type_1 | 2016-01-25 | 2016-01-25 | None | 1 | 1 | None | Product_Family_143 | Product_Name_251 | None | 2016-01-07 | Non Binding | Americas | None | None | Source_7 | Closed Won | NW America | 50688.0 | 50688.0 | USD | 0 |
| 8 | 2015-04-20 | Account_Name_1888 | Person_Name_50 | Account_Type_2 | NaN | NaN | JPY | Japan | None | Bureaucratic_Code_5 | 0 | 0 | None | Q1 | Delivery_Terms_4 | 2016 | 24353 | Person_Name_50 | 2016-04-05 | 2016 - 2 | 2015-12-09 | 8 | Opportunity_Name_6151 | Person_Name_50 | Opportunity_Type_7 | 2016-02-29 | 2016-02-29 | None | 0 | 1 | None | Product_Family_6 | Product_Name_6 | None | NaT | Non Binding | Japan | None | None | None | Closed Lost | None | 15600.0 | 470400.0 | JPY | 0 |
| 9 | 2015-04-20 | Account_Name_1888 | Person_Name_50 | Account_Type_2 | NaN | NaN | JPY | Japan | None | Bureaucratic_Code_5 | 0 | 0 | None | Q1 | Delivery_Terms_4 | 2016 | 24355 | Person_Name_50 | 2016-04-05 | 2016 - 2 | 2015-12-09 | 8 | Opportunity_Name_6151 | Person_Name_50 | Opportunity_Type_7 | 2016-02-29 | 2016-02-29 | None | 0 | 1 | None | Product_Family_4 | Product_Name_4 | None | NaT | Non Binding | Japan | None | None | None | Closed Lost | None | 4400.0 | 470400.0 | JPY | 0 |
Last rows
| Account_Created_Date | Account_Name | Account_Owner | Account_Type | ASP | ASP_(converted) | ASP_Currency | Billing_Country | Brand | Bureaucratic_Code | Bureaucratic_Code_0_Approval | Bureaucratic_Code_0_Approved | Currency | Delivery_Quarter | Delivery_Terms | Delivery_Year | ID | Last_Modified_By | Last_Modified_Date | Month | Opportunity_Created_Date | Opportunity_ID | Opportunity_Name | Opportunity_Owner | Opportunity_Type | Planned_Delivery_End_Date | Planned_Delivery_Start_Date | Price | Pricing,_Delivery_Terms_Approved | Pricing,_Delivery_Terms_Quote_Appr | Product_Category_B | Product_Family | Product_Name | Product_Type | Quote_Expiry_Date | Quote_Type | Region | Sales_Contract_No | Size | Source_ | Stage | Territory | Total_Amount | Total_Taxable_Amount | Total_Taxable_Amount_Currency | TRF | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16937 | 2013-07-27 | Account_Name_533 | Person_Name_13 | Account_Type_0 | 0.5300 | 0.59948 | EUR | Germany | None | Bureaucratic_Code_4 | 0 | 0 | None | Q1 | Delivery_Terms_2 | 2016 | 17683 | Person_Name_13 | 2015-12-18 | 2016 - 2 | 2015-12-04 | 12797 | Opportunity_Name_4060 | Person_Name_13 | Opportunity_Type_8 | 2016-02-29 | 2016-02-01 | None | 0 | 0 | None | Product_Family_77 | Product_Name_96 | None | 2016-01-03 | Non Binding | EMEA | None | None | Source_9 | Closed Won | Germany | 413400.00 | 528918.75 | EUR | 1 |
| 16938 | 2015-12-04 | Account_Name_586 | Person_Name_13 | Account_Type_2 | 0.4700 | 0.53161 | EUR | Germany | None | Bureaucratic_Code_5 | 0 | 0 | None | Q3 | Delivery_Terms_2 | 2016 | 28767 | Person_Name_13 | 2016-10-21 | 2016 - 8 | 2015-12-04 | 12798 | Opportunity_Name_5088 | Person_Name_13 | Opportunity_Type_19 | 2016-09-30 | 2016-08-15 | None | 0 | 1 | None | Product_Family_85 | Product_Name_110 | None | 2016-02-05 | Non Binding | EMEA | None | None | None | Closed Lost | Germany | 1307775.00 | 1307775.00 | EUR | 3 |
| 16939 | 2013-07-27 | Account_Name_533 | Person_Name_13 | Account_Type_0 | 0.5150 | 0.58251 | EUR | Germany | None | Bureaucratic_Code_4 | 0 | 0 | None | Q2 | Delivery_Terms_2 | 2016 | 18324 | Person_Name_13 | 2016-04-01 | 2016 - 4 | 2015-12-04 | 12799 | Opportunity_Name_7202 | Person_Name_13 | Opportunity_Type_1 | 2016-04-21 | 2016-04-01 | None | 1 | 1 | None | Product_Family_77 | Product_Name_96 | None | 2016-04-03 | Non Binding | EMEA | 224 | None | Source_9 | Closed Won | Norway | 401700.00 | 401700.00 | EUR | 1 |
| 16940 | 2014-06-16 | Account_Name_404 | Person_Name_13 | Account_Type_5 | 0.5300 | 0.53000 | USD | Germany | None | Bureaucratic_Code_5 | 0 | 0 | None | Q4 | Delivery_Terms_4 | 2016 | 20827 | Person_Name_13 | 2016-10-10 | 2016 - 10 | 2015-12-04 | 12800 | Opportunity_Name_11979 | Person_Name_13 | Opportunity_Type_19 | 2016-12-30 | 2016-10-03 | None | 0 | 1 | None | Product_Family_164 | Product_Name_307 | None | 2016-01-15 | Non Binding | Americas | None | None | None | Closed Lost | NE America | 10751580.00 | 21332500.00 | USD | 20 |
| 16941 | 2014-06-16 | Account_Name_404 | Person_Name_13 | Account_Type_5 | 0.5300 | 0.53000 | USD | Germany | None | Bureaucratic_Code_5 | 0 | 0 | None | Q4 | Delivery_Terms_4 | 2016 | 20830 | Person_Name_13 | 2016-10-10 | 2016 - 10 | 2015-12-04 | 12800 | Opportunity_Name_11979 | Person_Name_13 | Opportunity_Type_19 | 2016-12-30 | 2016-10-03 | None | 0 | 1 | None | Product_Family_158 | Product_Name_286 | None | 2016-01-15 | Non Binding | Americas | None | None | None | Closed Lost | NE America | 10580920.00 | 21332500.00 | USD | 20 |
| 16942 | 2016-01-15 | Account_Name_726 | Person_Name_13 | Account_Type_5 | 0.5200 | 0.58817 | EUR | Austria | None | Bureaucratic_Code_4 | 1 | 1 | None | Q1 | Delivery_Terms_2 | 2016 | 8781 | Person_Name_13 | 2016-01-19 | 2016 - 3 | 2015-12-04 | 12801 | Opportunity_Name_9245 | Person_Name_13 | Opportunity_Type_1 | 2016-03-25 | 2016-03-21 | None | 1 | 1 | None | Product_Family_85 | Product_Name_111 | None | NaT | Non Binding | EMEA | 44 | None | Source_7 | Closed Won | Austria | 103350.00 | 299715.00 | EUR | 0 |
| 16943 | 2016-01-15 | Account_Name_726 | Person_Name_13 | Account_Type_5 | 0.5200 | 0.58817 | EUR | Austria | None | Bureaucratic_Code_4 | 1 | 1 | None | Q2 | Delivery_Terms_2 | 2016 | 8786 | Person_Name_13 | 2016-01-19 | 2016 - 4 | 2015-12-04 | 12801 | Opportunity_Name_9245 | Person_Name_13 | Opportunity_Type_1 | 2016-04-08 | 2016-04-04 | None | 1 | 1 | None | Product_Family_85 | Product_Name_111 | None | NaT | Non Binding | EMEA | 44 | None | Source_7 | Closed Won | Austria | 93015.00 | 299715.00 | EUR | 0 |
| 16944 | 2016-01-15 | Account_Name_726 | Person_Name_13 | Account_Type_5 | 0.5200 | 0.58817 | EUR | Austria | None | Bureaucratic_Code_4 | 1 | 1 | None | Q1 | Delivery_Terms_2 | 2016 | 8792 | Person_Name_13 | 2016-01-19 | 2016 - 3 | 2015-12-04 | 12801 | Opportunity_Name_9245 | Person_Name_13 | Opportunity_Type_1 | 2016-03-31 | 2016-03-28 | None | 1 | 1 | None | Product_Family_85 | Product_Name_111 | None | NaT | Non Binding | EMEA | 44 | None | Source_7 | Closed Won | Austria | 103350.00 | 299715.00 | EUR | 0 |
| 16945 | 2015-10-20 | Account_Name_944 | Person_Name_3 | Account_Type_5 | 0.6375 | 0.63750 | USD | United States | None | Bureaucratic_Code_4 | 1 | 1 | None | Q2 | Delivery_Terms_4 | 2016 | 28561 | Person_Name_3 | 2016-01-22 | 2016 - 4 | 2015-12-05 | 12802 | Opportunity_Name_5843 | Person_Name_3 | Opportunity_Type_1 | 2016-04-29 | 2016-04-25 | None | 1 | 1 | None | Product_Family_158 | Product_Name_287 | None | 2016-02-29 | Non Binding | Americas | None | None | None | Closed Lost | NE America | 2346796.88 | 0.00 | USD | 4 |
| 16946 | 2015-09-03 | Account_Name_1401 | Person_Name_3 | Account_Type_5 | 0.6400 | 0.64000 | USD | United States | None | Bureaucratic_Code_4 | 1 | 1 | None | Q3 | Delivery_Terms_4 | 2016 | 28318 | Person_Name_3 | 2016-09-28 | 2016 - 7 | 2015-12-05 | 12803 | Opportunity_Name_9911 | Person_Name_3 | Opportunity_Type_19 | 2016-08-31 | 2016-07-01 | None | 1 | 1 | None | Product_Family_164 | Product_Name_307 | None | 2016-01-06 | Non Binding | Americas | None | None | None | Closed Lost | NE America | 25603200.00 | 0.00 | USD | 40 |